Go to the documentation of this file.
00001 using System;
00002 using System.Collections.Generic;
00003 using System.Data.SqlClient;
00004 using System.Text;
00005 
00006 using RAIS.Common.UserManagement;
00007 using RAIS.Common.DynamicMaskManagement;
00008 using RAIS.Common.Localization;
00009 
00010 namespace RAIS.DataAccessLayer
00011 {
00015     public class Help
00016     {
00017         public static string GetHelp(int categoryID, int subCategoryID, int maskID, int dynamicMaskID, int cultureID)
00018         {
00019             string helpText;
00020             using (SqlConnection sqlConnection = new SqlConnection(DataAccessUtilities.ConnectionString))
00021             {
00022                 sqlConnection.Open();
00023 
00024                 using (SqlCommand sqlCommand = new SqlCommand(Constants.SP_NAME_GetHelp, sqlConnection))
00025                 {
00026                     sqlCommand.CommandType = System.Data.CommandType.StoredProcedure;
00027 
00028                     DataAccessUtilities.AddParameter(sqlCommand, Constants.SP_PARAMETER_SupportedLanguage, cultureID);
00029                     DataAccessUtilities.AddParameter(sqlCommand, Constants.SP_PARAMETER_CategoryID, categoryID);
00030                     DataAccessUtilities.AddParameter(sqlCommand, Constants.SP_PARAMETER_SubcategoryID, subCategoryID);
00031                     DataAccessUtilities.AddParameter(sqlCommand, Constants.SP_PARAMETER_MaskID, maskID);
00032                     if (dynamicMaskID !=-1)
00033                         DataAccessUtilities.AddParameter(sqlCommand, Constants.SP_PARAMETER_DynamicMaskID, dynamicMaskID);
00034 
00035                     using (SqlDataReader sqlReader = sqlCommand.ExecuteReader())
00036                     {
00037                         sqlReader.Read();
00038                         helpText = (string)sqlReader[0];
00039                     }
00040                 }
00041             }
00042             return helpText;
00043         }
00044 
00045         public static void SaveHelp(int categoryID, int subCategoryID, int maskID, int dynamicMaskID, int cultureID, string helpText)
00046         {
00047             using (SqlConnection sqlConnection = new SqlConnection(DataAccessUtilities.ConnectionString))
00048             {
00049                 sqlConnection.Open();
00050 
00051                 using (SqlCommand sqlCommand = new SqlCommand(Constants.SP_NAME_UpdateHelp, sqlConnection))
00052                 {
00053                     sqlCommand.CommandType = System.Data.CommandType.StoredProcedure;
00054 
00055                     DataAccessUtilities.AddParameter(sqlCommand, Constants.SP_PARAMETER_SupportedLanguage, cultureID);
00056                     DataAccessUtilities.AddParameter(sqlCommand, Constants.SP_PARAMETER_CategoryID, categoryID);
00057                     DataAccessUtilities.AddParameter(sqlCommand, Constants.SP_PARAMETER_SubcategoryID, subCategoryID);
00058                     DataAccessUtilities.AddParameter(sqlCommand, Constants.SP_PARAMETER_MaskID, maskID);
00059                     DataAccessUtilities.AddParameter(sqlCommand, Constants.SP_PARAMETER_HelpText, helpText);
00060 
00061                     if (dynamicMaskID != -1)
00062                         DataAccessUtilities.AddParameter(sqlCommand, Constants.SP_PARAMETER_DynamicMaskID, dynamicMaskID);
00063 
00064                     sqlCommand.ExecuteNonQuery();
00065                 }
00066             }
00067         }
00068 
00069         public static string GetHelp(FunctionRole.Category category, FunctionRole.Subcategory subCategory, Mask mask,
00070                                 DynamicMask dynamicMask, Culture culture)
00071         {
00072                         if (mask == null)
00073                                 return string.Empty;
00074 
00075             if (dynamicMask == null)
00076                 return GetHelp(category.ID, subCategory.ID, mask.ID, -1, culture.ID);
00077             else
00078                 return GetHelp(category.ID, subCategory.ID, mask.ID, dynamicMask.ID, culture.ID);
00079         }
00080 
00081         public static void SaveHelp(FunctionRole.Category category, FunctionRole.Subcategory subCategory, Mask mask,
00082                                         DynamicMask dynamicMask, Culture culture, string helpText)
00083         {
00084             
00085             if(dynamicMask==null)
00086                 SaveHelp(category.ID, subCategory.ID, mask.ID, -1, culture.ID,helpText);
00087             else
00088                 SaveHelp(category.ID, subCategory.ID, mask.ID, dynamicMask.ID, culture.ID, helpText);           
00089         }
00090     }
00091 }